/*
 * @Description: xxx描述文件内容
 * @Autor: gufuyan
 * @Date: 2021-12-03 17:22:17
 * @lastModifiedBy: gufuyan
 * @LastEditTime: 2021-12-03 17:25:25
 * @lastModifiedContent:
 */
export const formulaData = [
  {
    key: 'frequently',
    title: '常用函数', //'formula.common',
    children: [
      {
        key: 'frequently-CONCATENATE',
        title: 'CONCATENATE',
        intro: 'formula.concatenate.intro',
        usage: 'formula.concatenate.usage',
        example: 'formula.concatenate.example',
        docUrl: 'https://hc.jiandaoyun.com/doc/9034',
      },
      {
        key: 'frequently-DATE',
        title: 'DATE',
        intro: 'formula.date.intro',
        usage: 'formula.date.usage',
        example: 'formula.omit',
        docUrl: 'https://hc.jiandaoyun.com/doc/9036',
      },
      {
        key: 'frequently-DATEDIF',
        title: 'DATEDIF',
        intro: 'formula.datedif.intro',
        usage: 'formula.datedif.usage',
        example: 'formula.datedif.example',
        docUrl: 'https://hc.jiandaoyun.com/doc/9036',
      },
      {
        key: 'frequently-IF',
        title: 'IF',
        intro: 'formula.if.intro',
        usage: 'formula.if.usage',
        example: 'formula.if.example',
        docUrl: 'https://hc.jiandaoyun.com/doc/9033',
      },
      {
        key: 'frequently-MAPX',
        title: 'MAPX',
        intro: 'formula.mapx.intro',
        usage: 'formula.mapx.usage',
        example: 'formula.omit',
        docUrl: 'https://hc.jiandaoyun.com/doc/9037',
      },
      {
        key: 'frequently-SUM',
        title: 'SUM',
        intro: 'formula.sum.intro',
        usage: 'formula.sum.usage',
        example: 'formula.sum.example',
        docUrl: 'https://hc.jiandaoyun.com/doc/9035',
      },
    ],
  },
  {
    key: 'math',
    title: '数学函数', //'formula.math',
    docUrl: 'https://hc.jiandaoyun.com/doc/9035',
    children: [
      {
        key: 'math-ABS',
        title: 'ABS',
        intro: 'formula.abs.intro',
        usage: 'formula.abs.usage',
        example: 'formula.abs.example',
      },
      {
        key: 'math-AVERAGE',
        title: 'AVERAGE',
        intro: 'formula.average.intro',
        usage: 'formula.average.usage',
        example: 'formula.average.example',
      },
      {
        key: 'math-CEILING',
        title: 'CEILING',
        intro: 'formula.ceiling.intro',
        usage: 'formula.ceiling.usage',
        example: 'formula.ceiling.example',
      },
      {
        key: 'math-COUNT',
        title: 'COUNT',
        intro: 'formula.count.intro',
        usage: 'formula.count.usage',
        example: 'formula.count.example',
      },
      {
        key: 'math-COUNTIF',
        title: 'COUNTIF',
        intro: 'formula.countif.intro',
        usage: 'formula.countif.usage',
        example: 'formula.countif.example',
      },
      {
        key: 'math-FIXED',
        title: 'FIXED',
        intro: 'formula.fixed.intro',
        usage: 'formula.fixed.usage',
        example: 'formula.fixed.example',
      },
      {
        key: 'math-FLOOR',
        title: 'FLOOR',
        intro: 'formula.floor.intro',
        usage: 'formula.floor.usage',
        example: 'formula.floor.example',
      },
      {
        key: 'math-INT',
        title: 'INT',
        intro: 'formula.int.intro',
        usage: 'formula.int.usage',
        example: 'formula.int.example',
      },
      {
        key: 'math-LARGE',
        title: 'LARGE',
        intro: 'formula.large.intro',
        usage: 'formula.large.usage',
        example: 'formula.large.example',
      },
      {
        key: 'math-LOG',
        title: 'LOG',
        intro: 'formula.log.intro',
        usage: 'formula.log.usage',
        example: 'formula.log.example',
      },
      {
        key: 'math-MAX',
        title: 'MAX',
        intro: 'formula.max.intro',
        usage: 'formula.max.usage',
        example: 'formula.max.example',
      },
      {
        key: 'math-MIN',
        title: 'MIN',
        intro: 'formula.min.intro',
        usage: 'formula.min.usage',
        example: 'formula.min.example',
      },
      {
        key: 'math-MOD',
        title: 'MOD',
        intro: 'formula.mod.intro',
        usage: 'formula.mod.usage',
        example: 'formula.mod.example',
      },
      {
        key: 'math-POWER',
        title: 'POWER',
        intro: 'formula.power.intro',
        usage: 'formula.power.usage',
        example: 'formula.power.example',
      },
      {
        key: 'math-PRODUCT',
        title: 'PRODUCT',
        intro: 'formula.product.intro',
        usage: 'formula.product.usage',
        example: 'formula.product.example',
      },
      {
        key: 'math-RAND',
        title: 'RAND',
        intro: 'formula.rand.intro',
        usage: 'formula.rand.usage',
        example: 'formula.rand.example',
      },
      {
        key: 'math-ROUND',
        title: 'ROUND',
        intro: 'formula.round.intro',
        usage: 'formula.round.usage',
        example: 'formula.round.example',
      },
      {
        key: 'math-SMALL',
        title: 'SMALL',
        intro: 'formula.small.intro',
        usage: 'formula.small.usage',
        example: 'formula.small.example',
      },
      {
        key: 'math-SQRT',
        title: 'SQRT',
        intro: 'formula.sqrt.intro',
        usage: 'formula.sqrt.usage',
        example: 'formula.sqrt.example',
      },
      {
        key: 'math-SUM',
        title: 'SUM',
        intro: 'formula.sum.intro',
        usage: 'formula.sum.usage',
        example: 'formula.sum.example',
      },
      {
        key: 'math-SUMPRODUCT',
        title: 'SUMPRODUCT',
        intro: 'formula.sumproduct.intro',
        usage: 'formula.sumproduct.usage',
        example: 'formula.sumproduct.example',
      },
    ],
  },
  {
    key: 'text',
    title: '文本函数', //'formula.text',
    docUrl: 'https://hc.jiandaoyun.com/doc/9034',
    children: [
      {
        key: 'text-CONCATENATE',
        title: 'CONCATENATE',
        intro: 'formula.concatenate.intro',
        usage: 'formula.concatenate.usage',
        example: 'formula.concatenate.example',
      },
      {
        key: 'text-CHAR',
        title: 'CHAR',
        intro: 'formula.char.intro',
        usage: 'formula.char.usage',
        example: 'formula.char.example',
      },
      {
        key: 'text-EXACT',
        title: 'EXACT',
        intro: 'formula.exact.intro',
        usage: 'formula.exact.usage',
        example: 'formula.exact.example',
      },
      {
        key: 'text-IP',
        title: 'IP',
        intro: 'formula.ip.intro',
        usage: 'formula.ip.usage',
        example: 'formula.omit',
      },
      {
        key: 'text-ISEMPTY',
        title: 'ISEMPTY',
        intro: 'formula.isempty.intro',
        usage: 'formula.isempty.usage',
        example: 'formula.omit',
      },
      {
        key: 'text-LEFT',
        title: 'LEFT',
        intro: 'formula.left.intro',
        usage: 'formula.left.usage',
        example: 'formula.left.example',
      },
      {
        key: 'text-LEN',
        title: 'LEN',
        intro: 'formula.len.intro',
        usage: 'formula.len.usage',
        example: 'formula.len.example',
      },
      {
        key: 'text-LOWER',
        title: 'LOWER',
        intro: 'formula.lower.intro',
        usage: 'formula.lower.usage',
        example: 'formula.lower.example',
      },
      {
        key: 'text-MID',
        title: 'MID',
        intro: 'formula.mid.intro',
        usage: 'formula.mid.usage',
        example: 'formula.mid.example',
      },
      {
        key: 'text-REPLACE',
        title: 'REPLACE',
        intro: 'formula.replace.intro',
        usage: 'formula.replace.usage',
        example: 'formula.replace.example',
      },
      {
        key: 'text-REPT',
        title: 'REPT',
        intro: 'formula.rept.intro',
        usage: 'formula.rept.usage',
        example: 'formula.rept.example',
      },
      {
        key: 'text-RIGHT',
        title: 'RIGHT',
        intro: 'formula.right.intro',
        usage: 'formula.right.usage',
        example: 'formula.right.example',
      },
      {
        key: 'text-SEARCH',
        title: 'SEARCH',
        intro: 'formula.search.intro',
        usage: 'formula.search.usage',
        example: 'formula.search.example',
      },
      {
        key: 'text-SPLIT',
        title: 'SPLIT',
        intro: 'formula.split.intro',
        usage: 'formula.split.usage',
        example: 'formula.split.example',
      },
      {
        key: 'text-TEXT',
        title: 'TEXT',
        intro: 'formula.text.intro',
        usage: 'formula.text.usage',
        example: 'formula.text.example',
      },
      {
        key: 'text-TRIM',
        title: 'TRIM',
        intro: 'formula.trim.intro',
        usage: 'formula.trim.usage',
        example: 'formula.trim.example',
      },
      {
        key: 'text-UNION',
        title: 'UNION',
        intro: 'formula.union.intro',
        usage: 'formula.union.usage',
        example: 'formula.union.example',
      },
      {
        key: 'text-UPPER',
        title: 'UPPER',
        intro: 'formula.upper.intro',
        usage: 'formula.upper.usage',
        example: 'formula.upper.example',
      },
      {
        key: 'text-VALUE',
        title: 'VALUE',
        intro: 'formula.value.intro',
        usage: 'formula.value.usage',
        example: 'formula.value.example',
      },
    ],
  },
  {
    key: 'date',
    title: '日期函数', // 'formula.date',
    docUrl: 'https://hc.jiandaoyun.com/doc/9036',
    children: [
      {
        key: 'date-DATE',
        title: 'DATE',
        intro: 'formula.date.intro',
        usage: 'formula.date.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-DATEDELTA',
        title: 'DATEDELTA',
        intro: 'formula.datedelta.intro',
        usage: 'formula.datedelta.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-DATEDIF',
        title: 'DATEDIF',
        intro: 'formula.datedif.intro',
        usage: 'formula.datedif.usage',
        example: 'formula.datedif.example',
      },
      {
        key: 'date-DAY',
        title: 'DAY',
        intro: 'formula.day.intro',
        usage: 'formula.day.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-DAYS',
        title: 'DAYS',
        intro: 'formula.days.intro',
        usage: 'formula.days.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-DAYS360',
        title: 'DAYS360',
        intro: 'formula.days360.intro',
        usage: 'formula.days360.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-HOUR',
        title: 'HOUR',
        intro: 'formula.hour.intro',
        usage: 'formula.hour.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-ISOWEEKNUM',
        title: 'ISOWEEKNUM',
        intro: 'formula.isoweeknum.intro',
        usage: 'formula.isoweeknum.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-MINUTE',
        title: 'MINUTE',
        intro: 'formula.minute.intro',
        usage: 'formula.minute.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-MONTH',
        title: 'MONTH',
        intro: 'formula.month.intro',
        usage: 'formula.month.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-NETWORKDAYS',
        title: 'NETWORKDAYS',
        intro: 'formula.networkdays.intro',
        usage: 'formula.networkdays.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-NOW',
        title: 'NOW',
        intro: 'formula.now.intro',
        usage: 'formula.now.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-SECOND',
        title: 'SECOND',
        intro: 'formula.second.intro',
        usage: 'formula.second.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-SYSTIME',
        title: 'SYSTIME',
        intro: 'formula.systime.intro',
        usage: 'formula.systime.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-TIME',
        title: 'TIME',
        intro: 'formula.time.intro',
        usage: 'formula.time.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-TIMESTAMP',
        title: 'TIMESTAMP',
        intro: 'formula.timestamp.intro',
        usage: 'formula.timestamp.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-TODAY',
        title: 'TODAY',
        intro: 'formula.today.intro',
        usage: 'formula.today.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-WEEKNUM',
        title: 'WEEKNUM',
        intro: 'formula.weeknum.intro',
        usage: 'formula.weeknum.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-WORKDAY',
        title: 'WORKDAY',
        intro: 'formula.workday.intro',
        usage: 'formula.workday.usage',
        example: 'formula.omit',
      },
      {
        key: 'date-YEAR',
        title: 'YEAR',
        intro: 'formula.year.intro',
        usage: 'formula.year.usage',
        example: 'formula.omit',
      },
    ],
  },
  {
    key: 'logic',
    title: '逻辑函数', //'formula.logic',
    docUrl: 'https://hc.jiandaoyun.com/doc/9033',
    children: [
      {
        key: 'logic-AND',
        title: 'AND',
        intro: 'formula.and.intro',
        usage: 'formula.and.usage',
        example: 'formula.and.example',
      },
      {
        key: 'logic-FALSE',
        title: 'FALSE',
        intro: 'formula.false.intro',
        usage: 'formula.false.usage',
        example: 'formula.omit',
      },
      {
        key: 'logic-IF',
        title: 'IF',
        intro: 'formula.if.intro',
        usage: 'formula.if.usage',
        example: 'formula.if.example',
      },
      {
        key: 'logic-IFS',
        title: 'IFS',
        intro: 'formula.ifs.intro',
        usage: 'formula.ifs.usage',
        example: 'formula.ifs.example',
      },
      {
        key: 'logic-NOT',
        title: 'NOT',
        intro: 'formula.not.intro',
        usage: 'formula.not.usage',
        example: 'formula.not.example',
      },
      {
        key: 'logic-OR',
        title: 'OR',
        intro: 'formula.or.intro',
        usage: 'formula.or.usage',
        example: 'formula.or.example',
      },
      {
        key: 'logic-TRUE',
        title: 'TRUE',
        intro: 'formula.true.intro',
        usage: 'formula.true.usage',
        example: 'formula.omit',
      },
      {
        key: 'logic-XOR',
        title: 'XOR',
        intro: 'formula.xor.intro',
        usage: 'formula.xor.usage',
        example: 'formula.xor.example',
      },
    ],
  },
  {
    key: 'advanced',
    title: '高级函数', //'formula.advance',
    docUrl: 'https://hc.jiandaoyun.com/doc/9037',
    children: [
      {
        key: 'advanced-DISTANCE',
        title: 'DISTANCE',
        intro: 'formula.distance.intro',
        usage: 'formula.distance.usage',
        example: 'formula.distance.example',
      },
      {
        key: 'advanced-GETUSERNAME',
        title: 'GETUSERNAME',
        intro: 'formula.getusername.intro',
        usage: 'formula.getusername.usage',
        example: 'formula.omit',
      },
      {
        key: 'advanced-MAPX',
        title: 'MAPX',
        intro: 'formula.mapx.intro',
        usage: 'formula.mapx.usage',
        example: 'formula.omit',
      },
      {
        key: 'advanced-RECNO',
        title: 'RECNO',
        intro: 'formula.recno.intro',
        usage: 'formula.recno.usage',
        example: 'formula.omit',
      },
      {
        key: 'advanced-TEXTLOCATION',
        title: 'TEXTLOCATION',
        intro: 'formula.textlocation.intro',
        usage: 'formula.textlocation.usage',
        example: 'formula.textlocation.example',
      },
      {
        key: 'advanced-TEXTUSER',
        title: 'TEXTUSER',
        intro: 'formula.textuser.intro',
        usage: 'formula.textuser.usage',
        example: 'formula.textuser.example',
      },
      {
        key: 'advanced-UUID',
        title: 'UUID',
        intro: 'formula.uuid.intro',
        usage: 'formula.uuid.usage',
        example: 'formula.omit',
      },
    ],
  },
];
